SQL для тестировщика

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

www.tg-me.com/ca/SQL для тестировщика/com.sql_for_qa/116

2.0K viewsJun 30, 2023 at 09:11

tg-me.com/sql_for_qa/116

Create: 2023-06-30
Last Update: 2025-07-01 21:49:44

Даны следующие таблицы:

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/116

SQL для тестировщика Telegram | DID YOU KNOW?

Export WhatsApp stickers to Telegram on iPhone

You can’t. What you can do, though, is use WhatsApp’s and Telegram’s web platforms to transfer stickers. It’s easy, but might take a while.Open WhatsApp in your browser, find a sticker you like in a chat, and right-click on it to save it as an image. The file won’t be a picture, though—it’s a webpage and will have a .webp extension. Don’t be scared, this is the way. Repeat this step to save as many stickers as you want.Then, open Telegram in your browser and go into your Saved messages chat. Just as you’d share a file with a friend, click the Share file button on the bottom left of the chat window (it looks like a dog-eared paper), and select the .webp files you downloaded. Click Open and you’ll see your stickers in your Saved messages chat. This is now your sticker depository. To use them, forward them as you would a message from one chat to the other: by clicking or long-pressing on the sticker, and then choosing Forward.

The lead from Wall Street offers little clarity as the major averages opened lower on Friday and then bounced back and forth across the unchanged line, finally finishing mixed and little changed.The Dow added 33.18 points or 0.10 percent to finish at 34,798.00, while the NASDAQ eased 4.54 points or 0.03 percent to close at 15,047.70 and the S&P 500 rose 6.50 points or 0.15 percent to end at 4,455.48. For the week, the Dow rose 0.6 percent, the NASDAQ added 0.1 percent and the S&P gained 0.5 percent.The lackluster performance on Wall Street came on uncertainty about the outlook for the markets following recent volatility.